SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=4 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=1 AND MATCH (t.strSearch) AGAINST ('+clothing +for +sale' IN BOOLEAN MODE)) AND iCityID IN (10533,11014,10858,11040,10253,10961,10424,11009,10308,10433,10189,10818,11109,10502,10577,10528,10879,16150,10799,11036,10978,10933,10187,10369,10731,10847,10508,11041,10339,10920,10352,10984,6900,10529,10240,6955,10815,11094,11008,10863,13034,10407,6901,10222,10223,10208,10748,10526,10919,10019,10531,10354,11027,11136,10740,6850,10662,11131,10020,10266,10593,11089,10028,10834,10721,10757,6966,9995,10625,9802,9850,10537,10547,9917,10990,10274,11001,11045,11134,6945,6949,10351,10877,10861,10755,9859,11012,10730,10315,10734,10035,10836,10067,6984,10592,10835,10715,10483,9856,9920,16241,9929,10837,11081,10151,11053,10614,11123,9875,11049,10160,10957,10118,10408,10898,10639,9862,10950,6932,10127,10029,9816,10217,10008,10166,10081,10603,10539,10991,10717,6867,9877,9876,9931,10066,10627,10725,9800,10449,10319,10575,10133,11034,10928,9976,10265,11043,10220,10058,10453,10034,11003,10116,10659,11022,10668,10404,10873,10830,10064,10476,10724,10650,11065,10940,10215,11032,7010,6965,11015,9962,9989,10704,9983,9894,9909,10726,10072,9823,10605,10872,10545,9905,6946,10691,6888,10032,10161,10481,10477,10570,10963,10063,9882,10082,10833,10853,11095,6897,10808,10495,9872,10447,9970,10854,9921,10823,11112,10729,10914,10496,9967,10062,9874,10870,10664,16202,10597,10824,10379,10251,10523,11035,9846,10736,9896,10334,10507,16112,10499,10497,10648,9996,10912,10396,11013,9919,9900,10913,10524,10015,16113,7007,10305,9884,10056,10291,11033,10332,10915,10388,10779,10065,10219,10739,10372,9914,10270,10038,10618,10158,10996,10013,10546,10410,11121,9838,10643,10252,10333,10666,10942,10134,10381,10192,10629,10809,9908,10169,10037,10568,9868,10583,11006,10665,10145,10515,10347,10607,10540,10023,10478,10080,10609,10567,11116,10714,10406,10588,10125,11126,10147,10120,10783,10462,10535,9848,10088,11120,10346,10420,10709,16152,10140,10468,10652,10752,10440,10290,10135,11004,10881,10735,10890,11057,11099,9973,10569,6863,11010,10049,10302,6980,10226,10747,10445,13028,10227,16126,9966,10510,10450,10599,10675,10555,10224,10543,10021,10698,10997,16144,16119,11038,10068,10790,10548,10972,10467,11091,9832,10505,10880,10094,10126,6894,6889,10926,10504,10405,9932,10384,10139,10758,10469,10012,10895,10458,11113,10423,10479,16198,9812,10976,10852,9821,9841,10281,10897,10584,16575,11090,10221,10316,9994,9820,11122,10455,10536,10276,9963,10759,10395,9835,11068,10014,10693,10882,10762,10788,6933,9941,16588,10144,10807,9904,10825,10391,10234,9939,11031,16519,10441,10128,10426,10621,10358,10633,10661,10269,10630,10314,10260,9947,10987,9883,10394,10911,10974,11042,11064,10563,9836,10782,9918,9866,10146,10979,10851,10271,10909,10207,16256,10437,9867,10829,10368,10772,10655,10150,13030,10604,10336,10904,9879,10383,10789,10010,6995,10541,10286,11108,10971,10030,10443,10268,10203,10075,10382,10471,10400,11059,10832,10461,10446,10781,10542,11124,10596,13016,10695,11130,10804,10228,10213,10574,10297,10814,10204,16589,10676,10683,10361,10233,10631,10485,10766,10769,11061,10247,10444,10677,10941,9809,9969,9936,10103,10738,9925,10780,10436,10261,9824,6986,10549,10413,10392,10378,11083,10522,10578,10964,10179,11019,10674,10209,10191,10753,9865,10018,10452,10342,10194,9979,9930,10216,10534,6973,11048,10943,10493,10001,10994,11000,9915,10212,10231,10249,10640,10947,10530,10651,10770,10325,10225,10923,10910,10636,10718,10132,10036,10091,10745,10512,16515,10871,10860,10353,10123,11054,9873,10456,10258,10200,10672,10337,11093,10401,10746,10427,10771,11100,10303,9890,10190,10338,9950,10490,10889,10855,6936,16249,10903,10983,10259,10412,11084,10687,10579,10110,6908,16128,10214,10968,10937,10708,10371,11117,10077,6925,6972,10154,9944,10617,10867,10241,6872,10611,10076,10491,9842,6979,11055,10073,10703,10702,10114,10580,10300,10581,9974,10756,10749,11011,9855,9911,10750,10312,13027,11066,9998,9895,9965,10908,10868,10188,10157,10778,10389,10803,10733,10876,10026,9999,10995,6952,9901,6953,9844,10002,10129,10148,10009,6971,10494,10801,10243,10551,7019,10498,10328,10057,10115,9860,7018,10706,10944,9839,16166,10432,10544,10848,10425,10152,16616,10916,10085,10857,10556,6998,10106,11125,7017,10438,10967,9807,9886,10566,10343,10051,9817,16595,11097,6923,10373,10932,9851,10089,9949,6937,10000,7004,10309,9943,10045,6912,10159,10532,9937,10689,10820,10484,10218,9933,10905,10017,10784,6930,10754,9934,10242,10113,10831,10705,10138,6934,10572,10697,9954,9984,10397,16185,10041,9891,11129,9818,10104,9986,10402,10016,9940,10896,7000,10050,9813,11133,10005,6886,6999,10111,9961,9927,10124,6948,9806,10011) ORDER BY FIELD(iCityID, 10533,11014,10858,11040,10253,10961,10424,11009,10308,10433,10189,10818,11109,10502,10577,10528,10879,16150,10799,11036,10978,10933,10187,10369,10731,10847,10508,11041,10339,10920,10352,10984,6900,10529,10240,6955,10815,11094,11008,10863,13034,10407,6901,10222,10223,10208,10748,10526,10919,10019,10531,10354,11027,11136,10740,6850,10662,11131,10020,10266,10593,11089,10028,10834,10721,10757,6966,9995,10625,9802,9850,10537,10547,9917,10990,10274,11001,11045,11134,6945,6949,10351,10877,10861,10755,9859,11012,10730,10315,10734,10035,10836,10067,6984,10592,10835,10715,10483,9856,9920,16241,9929,10837,11081,10151,11053,10614,11123,9875,11049,10160,10957,10118,10408,10898,10639,9862,10950,6932,10127,10029,9816,10217,10008,10166,10081,10603,10539,10991,10717,6867,9877,9876,9931,10066,10627,10725,9800,10449,10319,10575,10133,11034,10928,9976,10265,11043,10220,10058,10453,10034,11003,10116,10659,11022,10668,10404,10873,10830,10064,10476,10724,10650,11065,10940,10215,11032,7010,6965,11015,9962,9989,10704,9983,9894,9909,10726,10072,9823,10605,10872,10545,9905,6946,10691,6888,10032,10161,10481,10477,10570,10963,10063,9882,10082,10833,10853,11095,6897,10808,10495,9872,10447,9970,10854,9921,10823,11112,10729,10914,10496,9967,10062,9874,10870,10664,16202,10597,10824,10379,10251,10523,11035,9846,10736,9896,10334,10507,16112,10499,10497,10648,9996,10912,10396,11013,9919,9900,10913,10524,10015,16113,7007,10305,9884,10056,10291,11033,10332,10915,10388,10779,10065,10219,10739,10372,9914,10270,10038,10618,10158,10996,10013,10546,10410,11121,9838,10643,10252,10333,10666,10942,10134,10381,10192,10629,10809,9908,10169,10037,10568,9868,10583,11006,10665,10145,10515,10347,10607,10540,10023,10478,10080,10609,10567,11116,10714,10406,10588,10125,11126,10147,10120,10783,10462,10535,9848,10088,11120,10346,10420,10709,16152,10140,10468,10652,10752,10440,10290,10135,11004,10881,10735,10890,11057,11099,9973,10569,6863,11010,10049,10302,6980,10226,10747,10445,13028,10227,16126,9966,10510,10450,10599,10675,10555,10224,10543,10021,10698,10997,16144,16119,11038,10068,10790,10548,10972,10467,11091,9832,10505,10880,10094,10126,6894,6889,10926,10504,10405,9932,10384,10139,10758,10469,10012,10895,10458,11113,10423,10479,16198,9812,10976,10852,9821,9841,10281,10897,10584,16575,11090,10221,10316,9994,9820,11122,10455,10536,10276,9963,10759,10395,9835,11068,10014,10693,10882,10762,10788,6933,9941,16588,10144,10807,9904,10825,10391,10234,9939,11031,16519,10441,10128,10426,10621,10358,10633,10661,10269,10630,10314,10260,9947,10987,9883,10394,10911,10974,11042,11064,10563,9836,10782,9918,9866,10146,10979,10851,10271,10909,10207,16256,10437,9867,10829,10368,10772,10655,10150,13030,10604,10336,10904,9879,10383,10789,10010,6995,10541,10286,11108,10971,10030,10443,10268,10203,10075,10382,10471,10400,11059,10832,10461,10446,10781,10542,11124,10596,13016,10695,11130,10804,10228,10213,10574,10297,10814,10204,16589,10676,10683,10361,10233,10631,10485,10766,10769,11061,10247,10444,10677,10941,9809,9969,9936,10103,10738,9925,10780,10436,10261,9824,6986,10549,10413,10392,10378,11083,10522,10578,10964,10179,11019,10674,10209,10191,10753,9865,10018,10452,10342,10194,9979,9930,10216,10534,6973,11048,10943,10493,10001,10994,11000,9915,10212,10231,10249,10640,10947,10530,10651,10770,10325,10225,10923,10910,10636,10718,10132,10036,10091,10745,10512,16515,10871,10860,10353,10123,11054,9873,10456,10258,10200,10672,10337,11093,10401,10746,10427,10771,11100,10303,9890,10190,10338,9950,10490,10889,10855,6936,16249,10903,10983,10259,10412,11084,10687,10579,10110,6908,16128,10214,10968,10937,10708,10371,11117,10077,6925,6972,10154,9944,10617,10867,10241,6872,10611,10076,10491,9842,6979,11055,10073,10703,10702,10114,10580,10300,10581,9974,10756,10749,11011,9855,9911,10750,10312,13027,11066,9998,9895,9965,10908,10868,10188,10157,10778,10389,10803,10733,10876,10026,9999,10995,6952,9901,6953,9844,10002,10129,10148,10009,6971,10494,10801,10243,10551,7019,10498,10328,10057,10115,9860,7018,10706,10944,9839,16166,10432,10544,10848,10425,10152,16616,10916,10085,10857,10556,6998,10106,11125,7017,10438,10967,9807,9886,10566,10343,10051,9817,16595,11097,6923,10373,10932,9851,10089,9949,6937,10000,7004,10309,9943,10045,6912,10159,10532,9937,10689,10820,10484,10218,9933,10905,10017,10784,6930,10754,9934,10242,10113,10831,10705,10138,6934,10572,10697,9954,9984,10397,16185,10041,9891,11129,9818,10104,9986,10402,10016,9940,10896,7000,10050,9813,11133,10005,6886,6999,10111,9961,9927,10124,6948,9806,10011) ASC, p.tmPosted DESC LIMIT 24 clothing for sale, For Sale Classifieds, Buy Used, Electronics, Computers, Tablets, Mobiles in Hawthorne

Items for sale in Hawthorne - clothing for sale

Show more results

By Using this website, you agree to Terms of Use & Privacy Policy. Got it